package symptomsSearch;

import java.util.*;
import java.sql.*;

import javax.naming.NamingException;

import ctm.javacode.dbBean;

public class UnConfirmSymptoms {

	public List<String> ShowUnConfirmSymptoms() throws NamingException,
			SQLException {

		/*****************************************/
		dbBean db = new dbBean("jdbc/ctmpllab");
		db.Connected();
		/*****************************************/

		List<String> UnConfirmSymptomsList = new ArrayList<String>();

		String sqlQuery = "SELECT * from un_confirm_symptoms";
		ResultSet rs;
		rs = db.ExcuteQuery(sqlQuery);

		while (rs.next()) {

			UnConfirmSymptomsList.add(rs.getString("standard_symptoms"));

		}
		db.CloseConn();
		return UnConfirmSymptomsList;

	}

	public List<String> ShowUnConfirmOriginalSymptoms() throws NamingException,
			SQLException {

		/*****************************************/
		dbBean db = new dbBean("jdbc/ctmpllab");
		db.Connected();
		/*****************************************/
		List<String> UnConfirmOriginalSymptomsList = new ArrayList<String>();

		String sqlQuery = "SELECT * from un_confirm_symptoms";
		ResultSet rs;
		rs = db.ExcuteQuery(sqlQuery);

		while (rs.next()) {

			UnConfirmOriginalSymptomsList.add(rs.getString("symptom"));

		}
		db.CloseConn();
		return UnConfirmOriginalSymptomsList;

	}

}
